<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<?php
require_once 'include/common.inc.php';
$sql = 'SELECT DISTINCT id, user_name, user_pass, nickname, lastloginip, lastlogintime, logintimes, postcount FROM ie_users WHERE user_name = "kaireewu"';
?>
<ul>
<li><h2>fetch_array</h2>
    <?php var_dump($db->fetch_array($db->query($sql))); ?>
</li>
<li><h2>fetch_first</h2>
    <?php var_dump($db->fetch_first($sql)); ?>
</li>
<li><h2>result_first</h2>
    <?php var_dump($db->result_first($sql)); ?>
</li>
<li><h2>num_rows</h2>
    <?php var_dump($db->num_rows($db->query($sql))); ?>
</li>
<li><h2>fetch_row</h2>
    <?php var_dump($db->fetch_row($db->query($sql))); ?>
</li>
<li><h2>result</h2>
    <?php var_dump($db->result($db->query($sql), 0)); ?>
</li>
<li><h2>affected_rows()</h2>
    <?php var_dump($db->affected_rows()); ?>
</li>
</ul>
</body>
<?php
$db->close();
unset($db);
